<?php

use yii\db\Migration;

class m161104_052416_create_total extends Migration
{
    public function up()
    {
        $this->createTable('kd_total',[
            't_id'=>$this->primaryKey()->comment('序号'),
            'jt_num'=>$this->integer(10)->comment('集团数量'),
            'yey_num'=>$this->integer(10)->notNull()->comment('幼儿园数量'),
            'yey_id'=>$this->integer(10)->notNull()->comment('幼儿园id'),
            't_num'=>$this->integer(10)->notNull()->comment('幼师数量'),
            's_num'=>$this->integer(10)->notNull()->comment('幼儿数量'),
            'p_num'=>$this->integer(10)->notNull()->comment('家长数量'),
            'a_num'=>$this->integer(10)->notNull()->comment('文章数量'),
            'img_size'=>$this->integer(10)->notNull()->comment('图片容量'),
            'v_size'=>$this->integer(10)->notNull()->comment('视频容量'),
            'mes_num'=>$this->integer(10)->notNull()->comment('消息数量'),
            'p_a_num'=>$this->integer(10)->notNull()->comment('家长上传文章数量'),
        ]);

    }

    public function down()
    {
        $this->dropTable('ka_total');
    }

    /*
    // Use safeUp/safeDown to run migration code within a transaction
    public function safeUp()
    {
    }

    public function safeDown()
    {
    }
    */
}
